https://store-images.s-microsoft.com/image/apps.907.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.d4326de0-20a2-47f6-9006-9b10560434e4.1fe8a719-0278-4817-94a7-6e0665e76d4a
Email Any Report
by dataoutput
Just a moment, logging you in...
Just a moment, logging you in...
Generate and email any reports with dynamic date periods using Job Queue.
https://dataoutput.sg/email-any-report
Using Job Queue to generate and email any report with dynamically calculated dates.
- Replace the value for 'StartingDate' and/or 'EndingDate' with the keyword Today in the XML.
- Today will be the date of the job queue execution.
- Combine with the standard functionality of the date formula.
weekly report with recurring job queue running every Friday.
- StartingDate = Today-5D
- EndingDate = Today
monthly financial report with recurring job queue running every first day of the month.
- StartingDate = Today-1M-CM (first day of the previous month)
- EndingDate = Today-1D (last day of the previous month)
Attach the email scenario 'Email Any Report' to the preferred email account if required.
At a glance
https://store-images.s-microsoft.com/image/apps.7084.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.d4326de0-20a2-47f6-9006-9b10560434e4.8e4beda2-0a03-47b1-b2d7-c4e3b2c62f75
https://store-images.s-microsoft.com/image/apps.35369.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.ec116f20-e3e5-4d5f-88b0-9b068098b3c2
https://store-images.s-microsoft.com/image/apps.18133.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.c21684e8-4408-4c7a-a2ed-21c0d3dae12d
https://store-images.s-microsoft.com/image/apps.53578.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.d07c99a9-a88f-4898-96ad-aae616dffc4e
https://store-images.s-microsoft.com/image/apps.46473.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.6fe4175e-ffd7-4a02-aa04-db4d5c257337